This report shows the amount in arrears broken down into the different user-defined periods /age groups. On the other hand the printout according to portfolio at risk shows the total outstanding loan balance in the category of the oldest missed payment at a given date.
Note that:
1. The Ageing Loans Classes report is displayed as at the first date (Date 1) i.e "Report date from". E.g 28/01/2021 as shown in the image below.
2. The principles due shown in the report will displayed as at the two dates i.e from date and to date and not the period range.
4. One has to ensure that the defined period under System/Configuration/Loan Product Settings/GL Accounts 2/2 is long enough to cover all loan ages. For Loans falling in ages not covered by the period selected, the system will return no loans.
5. The two dates "Reporting date from" and reporting date "to" determine which loan class each loan will fall.
How to view the Ageing Loans Classes report
To view the Ageing Loans Classes report you go to Loans/Portfolio Reports/Group Members Ageing Report and the following screen appears:
Reporting date from: In the drop down, enter the date from which you want the ageing loan classes report to be generated e.g. "28/01/2021". And on the To date enter the date up to which you want the ageing loan classes report to be generated e.g "31/01/2021"
Branch code: From the drop down select the Branch code that you want to report on e.g KA
Loan Fund: From the drop down, select a particular Loan Fund that you want to the ageing report generated e.g "World Bank Grant". For the loan funds to appear here, they should have been entered under System/Configuration/Funds.
Include all active loans (not only arrears): Select this option if you want the report to include all active loans and not just those that are in arrears.
Additional filtering options: This option is used to get a particular field or specification that you want. It helps you to narrow down the search for information that you need. When you check this option and click OK, a pop up screen will appear. See below:
More classes: Click this checkbox to add or remove an arrear class.
In the Additional filtering options pop up screen, select the required filter criteria from the drop down boxes, e.g., NAME='Ananth Angel Moger', Relational Operator, e.g., "=" (Equals sign) AND ClientCode, e.g., "KA/I/000003".
Click the OK button if all the data entered is sufficient.
You will get another pop up information screen showing the filter for the ageing report that was selected. As seen below:
Report currency: From the drop down select the currency in which the report will appear, e.g., "UGX". In case the report has transactions in other currencies too, then LPF will convert all other transactions in to the report currency.
Loan Product: From the drop down box, select a loan Product that you want to generate a report about. The Loan product depends on what was set at Menu System/Configuration/Products. You may have Loan Products like School Fees Loans, Agricultural Loans etc. In the example above, the "For all" option is selected in order to have an arrears report for all Loan Products
Arrears classes: When this option is selected, the ageing report will display the amount in arrears according to arrears classes.
Portfolio Classes: When this option is selected, the ageing report will display the amounts in arrears as a percentage of Portfolio at Risk for each loan and the overall average of PAR percentage for all the loans.
Print order: Select from the drop down box how the ageing report should be generated or classified i.e. in the column title/heading. In the first screen on this page, client name is selected
Include loans with dues on reporting date: Select this option and the report will display loans in arrears including those that fall due on the reporting date.
Click the Ok button to generate the report that will look like one below for ageing by Arrears classes:
The ageing report by portfolio classes will look like one below:
